Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 006 / javlrn2.arc / WORKSHT.CAS (.txt) < prev next >

Wrap

Javelin Case Study | 1985-10-01 | 43.8 KB | 1,141 lines

WORKSHT0 ~0Copyright (c) 1985 Javelin Software Corporation. S/N 0412345679 Press [F1] for Help. Version E4.69 Diagram view Table view READY &THE JAVELIN WORKSHEET $This case study shows some ways $to use worksheets in Javelin. $- Press [Space] to continue - $- or press [F1] for Help - 228K The Worksheet view is the most flexible} $ of Javelin's views, with ~$many powerful features. In this case ~$study, you'll see how to use some of these features. ~"You'll also see how to use several ~%of the *Worksheet commands, Javelin's ~ special commands for worksheets. %Example~ : Chisel & Gouge Furniture Co. ~% Chisel & Gouge Furniture Co. builds ~$ desks, dressers, and tables at two locations: Omaha and Topeka. ~# Use Javelin worksheets to examine ~% the production of each item at each ~ location. } $The production data for Chisel & ~"Gouge Furniture Co. is stored in a model called CHISEL. ~$To load the model, use the File Load command. Type: & $/' $F' $L' $} 'chisel DEFINE } CLEAR WINDOW PRINT MENU ~MDefine variable, building block, worksheet, graph, macro, time pd., settings. Delete Import ... Save Load FILE Load a model file from disk. m view READY ~ Filename: WAIT chisel.mdl Sep 1986 Jun 1987 . Aug 1986 May 1987 Feb 1988 Jul 1986 Apr 1987 Jan 1988 Jun 1986 Mar 1987 Dec 1987 May 1986 Feb 1987 Nov 1987 Apr 1986 Jan 1987 Oct 1987 Mar 1986 Dec 1986 Sep 1987 Feb 1986 Nov 1986 Aug 1987 Jan 1986 Oct 1986 Jul 1987 Omaha Desks = Monthly data: January 1986 - December 1986 Formulas for all variables: Omaha Tables = Monthly data: January Omaha Dressers = Monthly data: Janua Omaha Desks = Monthly data: January READY chisel.mdl chisel.mdl loaded. ~$Javelin loads the model. You see the ~$Table view in the top window and the ~#Formulas view in the bottom window. his model contains data for the ~%three variables shown in the Formulas view. ~$The Table view shows one variable at a time. ~ The Worksheet view can show many variables at once. To see a ~!worksheet, use the View Worksheet command: & $/' $V' $W' DEFINE CLEAR WINDOW PRINT FILE MENU ~)Load, save, import, or delete disk files. Graph Macro Errors Notes Worksheet Quick graph Chart Table Formulas ... Diagram VIEW Show diagram in current window. ~#Show a worksheet in current window. Monthly data: J Monthly data: Janu variables: Jun 19 May 19 Apr 19 Mar 19 Feb 19 Jan 19 Dec 19 Nov 19 Oct 19 Omaha Desks = Monthly data: January 1986 - December 1986 Worksheet name: ~!At the top of the screen, Javelin ~"prompts you to name the worksheet. ~"You can have as many worksheets as ~%you like, each with a different name. Let's call this worksheet } %Production~ Type: 'Production READY Production & }*$ Before we go on, let's talk about the parts of this worksheet. The } %worksheet borders~ are the shaded ~%areas at the top and left side of the worksheet. %body~ of the worksheet is the area ~&below and to the right of the borders. The borders control what y} $ou see in the body of the worksheet. %name} $ of the worksheet Production -- is at the top. ~"The worksheet is divided into rows and columns of %cells~ . A cursor marks on}#$e cell. Right now, the cursor is at ~#the top left corner of the borders. ~$You can move the cursor from cell to ce}#$ll with arrow keys. For example, to ~&move the cursor down one cell, press: ( ~!To see data in the worksheet, you ~"have to fill in variable names and dates in the bo} $rder cells. For example, to enter } %Omaha Desks~ cell at the cursor, type: & $O'm'a' ~"Now use the SPELL key to spell out ~$the rest of the name; then enter it: WAIT READY WAIT Omaha Tables Omaha Dressers Omaha Desks POSSIBILITIES READY WAIT Desks READY Omaha Desks WAIT READY Omaha Desks ~"You entered a variable name in the ~"left border. To see data, you must also enter dates i} $n the top border. ~"Move the cursor to the top border: Enter a date: 'Jan86 Jan 1986 WAIT READY Jan 1986 ~"In the cell at the intersection of ~$the name and the date, Javelin shows ~ you the value of Omaha Desks for January 1986. }%$Watch the information line at the top ~%of your screen as you move the cursor down to the number: Omaha Desks @ January 1986: 97 ~#The information line tells you what ~"you see in the cell at the cursor: %Omaha Desks @ January 1986~ identifies ~"the variable and the date shown in the cell at the cursor. The colon ( ) is equivalent to the equals sign in a formula. 9%7%} $ is the value of Omaha Desks for January 1986. &The * Worksheet Commands ~ Now let's enter dates in the top }%$border for the rest of the months in 1986. ~!You can enter several consecutive dates with } $one of the *Worksheet commands (pronounced "star Worksheet"). These commands are } $available in the worksheet only. 1986 - December 1986 ry 1986 - December 1986 ~ To use the command that fills in ~!dates in a border, first move the cursor to the top border: Jan 1986 ~ hen type /%*%~ to see the list of *Worksheet commands: & $/' $*' DEFINE CLEAR VIEW WINDOW PRINT *WORKSHEET MENU Select view for current window. Width Format Sort ... Exception Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Copy contents of cells. ~ You see a menu of the *Worksheet ~"commands -- commands that apply to $worksheets. ~"The command to fill in consecutive ~$dates is the *Worksheet Border Dates . Type B%~ to selec t$ $} %Border~ & $B' Shrink border Expand border Remove border Insert border Variable names Dates Border ... Enter dates in current border. Then type to select } %Dates~ & $D' ~ Format Sort ... Exception Name change Import file Range ... Border ... Data copy Copy 1986 Production READY Begin date (January 1986): At the top of your screen, the command prompts you for the first date in the range of dates to fill. Type: $ $ $ 'Jan86 End date (December 1986): ~%Then enter the last date in the range ~ of dates: 'Dec86 WAIT READY Feb 1986 Mar 1986 Apr 1986 May 1986 WAIT READY Jan 1986 ~!Javelin enters all the dates from January to December 1986. The ~%worksheet shows data from the model's $central base of information. ~#By entering dates, you told Javelin ~!to show the production values for Omaha Desks throughout 1986. Now let's show the rest of the variables. Move to first empty cell in the left border: $ $ Omaha Desks @ January 1986: 97 ~"Use the SPELL key to help type the variable name %Omaha Dressers~ & $O'm'a' $} WAIT READY WAIT Omaha Tables Omaha Dressers Omaha Desks POSSIBILITIES READY Select Omaha Dressers from ~ POSSIBILITIES menu and enter the name: WAIT -Omaha Desks Dressers READY Omaha Dresse WAIT READY Omaha Dressers ~ Javelin shows you the values for ~$Omaha Dressers. The name is cut off, ~#since the border is not wide enough to show the full name. ~"ress [Space] and I'll add the last variable name. Omaha Tables WAIT READY Omaha Tables ~"The worksheet now shows values for all the variables in the model. ~ Let's widen the left border so a the variable names will fit. 1986 - December 1986 ry 1986 - December 1986 ~$To change the width of a column, use ~#the *Worksheet Width command. Type: $ $ & $/' $*' $W' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Width Format Sort ... Exception Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET ~JInsert, remove, expand, shrink, enter dates or variable names in a border. Change width of current column. 1986 -Apr 1986 -May 1 Production READY ~DWidth: Use arrow keys and press , enter a number, or press [Del]. Column width (13): This command prompts you at the top of the screen to enter a column width. The current width, as shown in the parentheses, is 13 characters. ~$You can change the column width with keys, or by entering a ~&number. Watch the border as you press: ~ Jan 1986 ~ Feb 1986 ~ Mar 1986 ~ Apr 1986 ~ May 1986 WAIT READY ~ Jan 1986 ~ Feb 1986 ~ Mar 1986 ~ Apr 1986 ~ May 1986 WAIT READY ~#Now the name Omaha Dressers fits in left column. To complete the ~%command and set the new column width, press: Omaha Tables ~$The *Worksheet Width command changes ~$the width of a single column. On the ~%Worksheet settings sheet, you can set width for all the columns on a worksheet. ~#Use the Define Worksheet command to }!$see the Worksheet settings sheet: & $/' $D' $W' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Settings Configuration Printer Time period Macro ... Graph Worksheet Building block Variable DEFINE ~@Create a variable or change its name, period, or other settings. ~? Create a worksheet or change its name, column width, or format Omaha Desks = Formulas for all v Omaha Tables -Omaha Dressers -Omaha Desks Production Worksheet name (Production): ~!command prompts for the name of a ~"worksheet. To see the settings for ~&the current worksheet, just press Default Guilder (fl) Deutsche Mark Swiss Franc ( Franc (F) Yen ( Pound ( Dollar ($) Commas Percent Fixed decimal Automatic "Format Decimal places {} Column width {13} Name {Production} "Worksheet Settings ~7To save settings and leave settings sheet, press [Esc]. %Column width~ setting is 13. ~#Columns in the Production worksheet are 13 characters wide. o change the column width to 8 characters, move the cursor to %Column width~ and enter 8: ' $8' $} Column width: ~7To save settings and leave settings sheet, press [Esc]. ~"Now watch the worksheet as you pre ~"[Esc] to leave the settings sheet: '[Esc] hly data: January nthly data: Janua ly data: January ables: 187 125 -n 1986 -Feb 1986 -Mar 1986 Production ~?Jan 86 Feb 86 Mar 86 Apr 86 May 86 Jun 86 Jul 86 Aug 86 126 192 WAIT MENU READY Omaha Tables All the columns except the left }!$border are now 8 characters wide. $The left border is still 15 ~#characters wide, since you used the ~$*Worksheet Width command to set its column width explicitly. &Moving Around the Worksheet ~ With narrower columns, you can s ~"more months at once. To see months ~#off the screen, though, you have to move the cursor to the right to scroll the worksheet. The easiest way to scroll the works} $heet is to move the cursor with the arrow keys. ~%For example, to see the September and October values, press: @ January 1986: 187 February 1986: 183 March 1986: 189 April May 1986: 204 June 1986: 2 August 1986: 186 September 1986: 189 October 1986: 189 worksheet scrolls to show September and October 1986. ~&To see the last values in a worksheet, ~"press [End] and an arrow key. (The ~ [End] key is next to the key.) Press: '[End] ~)End: Press arrow key to select direction. WAIT READY ~ Omaha Tables @ October 1986: 189 December 1986: 194 hows the data for May through December 1986. move the cursor back to the top ~%left corner of the worksheet, use the ~%Home] key. (The [Home] key is next to key.) Press: '[Home] ~ Pressing [Home] always moves the ~#cursor to the top left corner cell. ~#Some other keys you can use to move ~!the cursor around worksheets are: [PgUp] -- Up one page [PgDn] -- Down one page [Ctrl]-[ ] -- Left one page [Ctrl]-[ ] -- Right one page &Headings and Subheadings~ ~&The Production worksheet we just built ~&shows one way to organize your data in Worksheet view. ~$Next, you'll see how to use headings ~%and subheadings to organize your data ~$another way, by putting parts of the variable names in each border. ~!All three variables in this model contain the word } %Omaha~ . This means ~#that you can group them all under a ~"single heading in the left border. ~$First, let's clear all the existing ~%variable names from the left border. ~&Move the cursor to Omaha Desks. Press: Omaha Desks ~&Then press the [Del] key to delete the ~#name. (The [Del] key is below the key, at the lower right of your keyboard.) Press: '[Del] WAIT Tables ressers READY ressers ~"After you delete the variable name ~#from the left border, the worksheet $no longer shows data for that ~ variable. ~!Although you removed the variable from the worksheet, } %you did not %remove it from the model.~ You can s ~%in the bottom window that Omaha Desks $is still in the model. Now delete the other two names: '[Del] '[Del] WAIT Tables READY Tables WAIT READY With the left border empty, the ~"worksheet no longer shows data for any variables. ~%There is another way to show the data ~ for the variables in this model. $First, type } %Omaha~ in the left border: 'Omaha Omaha WAIT READY Omaha Move down one cell: Now indent } %Desks~ under } %Omaha~ ~$indent the name, press the space bar once, then type Desks: '[Space] 'Desks Desks WAIT READY Desks ~"Javelin automatically combines the ~"two names when you indent one name under another. The first r} $ow shows the data for Omaha ~$Desks. Move the cursor to the right: Omaha Desks @ January 1986: 97 ~#Look at the top of your screen. The ~&cell at the cursor shows the value for ~%Omaha Desks @ January 1986, combining the heading %Omaha~ , the subheading %Desks~ , and the date %Jan 1986~ ~$You can use this kind of indentation ~&in the left border to build worksheets ~#of infinite variety. You can indent }$$to any number of levels, using dates ~!or parts of variable names in any combination of headings and subheadings. Press [Space} $] now, and I'll fill in $the rest of the variable names. Desks Dressers WAIT READY Dressers Tables WAIT READY Tables ~$Let's recap what you've seen so far: Use the View Worksheet command to create a worksheet. Enter names and dates in the ~$ borders to determine what to show. Use *Worksheet commands to change ~ the appearance of a worksheet. &Copying Groups of Cells ~$It's easy to create another group of ~$variables similar to the group under ~!Omaha. We can duplicate this same structure for Topeka, the other location where Chisel & Gouge produces furniture. ~"First, move the cursor down to the cell w} $here you want to enter the second heading: ~"Now enter the new heading, Topeka: 'Topeka Topeka WAIT READY Topeka ~&Instead of typing the same three names ~$-- Desks, Dressers, and Tables -- we ~#can use the *Worksheet Copy command to copy them under Topeka. ~!To use the Copy command, begin by ~!moving the cursor to the first ce you want to copy: Tables Dressers ~#Select the *Worksheet Copy command: $ $ & $/' $*' $C' DEFINE } CLEAR WINDOW PRINT *WORKSHEET MENU ~N Define variable, building block, worksheet, graph, macro, time pd., settings. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Change width of current column. Copy contents of cells. 200 120 -Jun 86 Jul 86 Au Production READY POINT ~FSpecify range to copy from: move to corner of range and press . or ~#Next, specify the range of cells to ~!copy. Press the period key (.) to anchor one end of the range on %Desks~ & $.' ~8Press arrows to show range, then press to select it. ~!Use the arrow keys to "paint" the range of cells to copy. ~#Javelin highlights the cells as you ~!point to them. Press when you ~$finish specifying the range to copy: READY POINT ~DSpecify range to copy to: move to corner of range and press . or ~$You have specified the range you are copying } %from~ . Now specify the range you are copying $t%o%~ ~%Move the cursor to point to the first ~#cell where the copy should appear, then press '[End] ~)End: Press arrow key to select direction. WAIT POINT ~DSpecify range to copy to: move to corner of range and press . or READY WAIT Desks Dressers Tables READY Desks ~!Javelin copies the three indented names un} $der Topeka. The worksheet is now set up for t} $hree more variables: ~"Topeka Desks, Topeka Dressers, and Topeka Tables. ~&These three variables do not yet exist ~#in the model. They do not appear in }#$the Formulas view, and they have no $data. $ $}!&Creating Variables on a Worksheet When you enter a number at the ~ intersection of a variable and a ~!date in a worksheet, you create a new variable in the model. is section, you will create ree new variables by entering numbers in the worksheet. ~#Let's begin by entering the January ~"1986 value for Topeka Desks. Watch ~"the top of your screen as you move ~ the cursor to the cell for Topek Desks in January 1986: Omaha Desks @ January 1986: 97 ressers @ January 1986: 125 Tables @ January 1986: 187 Topeka Desks: ~$As you move the cursor to each cell, the information line at top of ~%the screen describes what is shown in cell. ~"Right now, the cursor is on the ce ~$for Topeka Desks. Since Topeka Desks }#$is not yet defined, the information ~#line shows nothing after the colon. ~%The furniture shop in Topeka made 135 desks in January. Watch Formulas ~ view in the bottom window as you enter this number: & $1'3'5' $ Topeka Desks: WAIT ~&Topeka Desks = Monthly data: January READY ~ Topeka Desks @ January 1986: 135 ~ When you enter the data, Javelin ~"creates the variable Topeka Desks. opeka Desks is now part of the ~!model. Its formula appears at the ~"bottom of the Formulas view in the ~#bottom window. The information line ~#shows that Topeka Desks has a value $of 135 in January 1986. ~#This information is now part of the entral base of information, accessible in all views. ~%Now enter a value for Topeka Dressers ~%in January 1986. Move the cursor down ~ one cell and type the value 146: $ $ ' $1'4'6' ressers: Topeka Dressers: ~$Then enter the value by pressing the down-arrow key: WAIT ~&Topeka Dressers = Monthly data: Janu READY Topeka Tables: ~%As you enter this value, Javelin adds Topeka Dressers to the model. }%$You can build a whole model this way, starting on the worksheet. The ~$Worksheet view is especially useful ~#when you want to organize variables under separate headings. ~!Finally, enter a value for Topeka ables: & $2'1'3' $ Topeka Tables: WAIT ~&Topeka Tables = Monthly data: Januar READY ~!Topeka Tables @ January 1986: 213 ~&Press [Space] now, and I'll enter some ~#more data for furniture produced in Topeka. Dressers @ January 1986: 146 esks @ January 1986: 135 February 1986: Topeka Desks @ February 1986: WAIT READY Topeka Desks @ March 1986: Topeka Desks @ March 1986: WAIT READY Topeka Desks @ April 1986: Topeka Desks @ April 1986: WAIT READY Topeka Desks @ May 1986: Topeka Desks @ May 1986: WAIT READY Topeka Desks @ May 1986: 141 ~)End: Press arrow key to select direction. WAIT READY Topeka Desks @ May 1986: 141 Desks ressers ~#Topeka Dressers @ January 1986: 146 February 1986: ~ Topeka Dressers @ February 1986: WAIT READY Topeka Dressers @ March 1986: Topeka Dressers @ March 1986: WAIT READY Topeka Dressers @ April 1986: Topeka Dressers @ April 1986: WAIT READY Topeka Dressers @ May 1986: Topeka Dressers @ May 1986: WAIT READY Topeka Dressers @ May 1986: 153 ~)End: Press arrow key to select direction. WAIT READY Topeka Dressers @ May 1986: 153 ~ Dressers Tables ~!Topeka Tables @ January 1986: 213 February 1986: Topeka Tables @ February 1986: WAIT READY Topeka Tables @ March 1986: Topeka Tables @ March 1986: WAIT READY Topeka Tables @ April 1986: Topeka Tables @ April 1986: WAIT READY Topeka Tables @ May 1986: Topeka Tables @ May 1986: WAIT READY Topeka Tables @ May 1986: 225 Omaha &Changing Names on a Worksheet ~#Like the other views, the Worksheet $view is a way to see and enter ~%information in Javelin's central base ~!of information. The variables and dates are not really i%n%~ the worksheet ~#-- the worksheet is just one way of looking at them. ~%You saw this before, when you deleted rows} $ from the worksheet, but the ~#variables and data were not deleted central base of information. ~!Similarly, if you type a new name ~#ver an existing name in a worksheet border, you do not ch} $ange the existing variable name. For example, suppose the Omaha ~%furniture facility is not actually in ~ Omaha, but in the nearby town of East Omaha. Typing } %East Omaha~ over %Omaha~ does not change the name of the existing variable. Instead, it tells the ~"worksheet to show values for a new variable called East Omaha. ~!To see this, try entering the new ~#name, East Omaha, on the worksheet. ~"Use the EDIT key to put "Omaha" on the edit line, then add %East~ a space} $ to the name: '[F2] 'East '[Space] Omaha EOmaha aOmaha sOmaha tOmaha Omaha ~$Now watch the worksheet as you enter the new name: East Omaha WAIT READY East Omaha ~#All the Omaha values disappear from the worksheet. ~&The Omaha variables still exist -- you ~$can see their formulas in the bottom ~$window. But since no variables exist that begin with East Omaha, the }"$worksheet shows nothing under East Omaha. ~&Press [Space] and I'll change the name back to Omaha. Omaha WAIT READY Omaha You see the values of the Omaha variables once again. ~$If you want to change variable names ~$from the worksheet, you must use the ~#*Worksheet Name change command. For ~#example, let's change all the Omaha variables to East Omaha. Type: & $/' $*' $N' DEFINE CLEAR WINDOW PRINT *WORKSHEET MENU ~"Commands specific to current view. Name change Import file .. Range ... Border ... Data copy Copy *WORKSHEET Copy contents of cells. ~=Rename variables by changing a border item or exception cell. 200 120 -Jun 86 Jul 86 Au Production READY Rename to: Omaha ~$The command prompts you with the old name on the edit line. Add %East~ and a space to the name: 'East '[Space] EOmaha aOmaha sOmaha tOmaha Omaha Now watch the worksheet as you complete the command: WAIT East Omaha ~&East Omaha Tables = Monthly data: Ja ~&East Omaha Dressers = Monthly data: ~&East Omaha Desks = Monthly data: Jan READY East Omaha ~"is time the values stay visible in the worksheet. ~"The *Worksheet Name change command }!$actually changes the names of the ~$variables in the model, not just the names shown in the border. ~%You can see the new variable names in $the Formulas view. &Automatic Period Conversions ~ Before we leave this case study, we'll see one other feature of ~$Javelin worksheets: automatic period ~%conversions. You can use this feature ~%to convert variable values to another ~%period, simply by entering a date in a worksheet border. ~ For example, suppose you want to compu} $te quarterly production by summing the appropriate monthly values. All you have to do is enter a ~!quarterly date in the top border, ~ and Javelin will make the period conversion automatically. ~$To see quarterly production figures, ~"first move the cursor to the place where you want to type } %1 Q 86~ Jan 1986 ~%Then press the [Ins] key (next to the ~"[Del] key) to insert a new column: '[Ins] Apr WAIT READY ~$Javelin inserts a new column in the ~ worksheet. Now enter a new date: '1Q86 1 Q 86 WAIT READY 1 Q 1986 ~"Javelin automatically converts the ~#monthly values to quarterly values. ~%This is all you need to do to convert between periods on a worksheet. &Summary ~& Here are some of the features you saw in this case study: Headings and indented subheadings $in the left border. Creating variables from a worksheet. Automatic period conversions. You used the fo} $llowing keys to move around the worksheet: [Home] to move to the upper left corner of the worksheet. [End] to move to the last cell entry in a specified direction. [Ins] and [Del] to insert and delete rows or columns. You also used the following *Worksheet commands: Border Dates -- fill in dates in a ~ border. Width -- change the width of a ~ column. Copy -- copy a range of cells. Name change -- change names of variables. Related case studies: %More on the Javelin Worksheet~ shows ~$more about worksheets, including how ~#to enter and copy formulas, and how to create multiple worksheets. }#%Importing Data into a Javelin Model describes three ways to import ~!information into a Javelin model, ~!including importing a 1-2-3 file. }$%Entering Data and Formatting Numbers ~!shows how to use numeric formats.